package com.pantuo.sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pantuo.sys.bo.UpdateInfo;
import com.pantuo.sys.pojo.Log;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

/**
 * Created with IntelliJ IDEA.
 *
 * @Author: 炳秦
 * @Date: 2021/10/15/11:22
 * @Description:
 */
@Mapper
public interface SfzLogDao extends BaseMapper<Log> {

    public int findThisMonthCount(String date_s);

    public List<Map<String, Object>> findObjectByNameOrCardId(String nameOrCardId);

    public void updateBatch(@Param("list") List<Log> list);

    public void updateSfzLog(Log log);

    @Update("update tn_sfzlog set update_i = 1 where id = #{id}")
    public void updateStateById(Integer id);

    //根据特殊符号查询优化后姓名
    //@Select("select ")
    public void selectAfterUpdateNameById(String sign);

    @Select("select min(id) from tn_sfzlog where created_dt like #{created}")
    public Integer selectMinId(String created);

}
